<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">




<title>关于开启Sql Server 2005 Express版本的远程连接功能（备忘）  - 最远距离 - 博客园</title>
<meta name="keywords" content="关于开启Sql,Server,2005,Express版本的远程连接功能,备忘">




<link title="RSS" type="application/rss+xml" rel="alternate" href="http://www.cnblogs.com/lwlzyjl/rss">
<link title="RSD" type="application/rsd+xml" rel="EditURI" href="http://www.cnblogs.com/lwlzyjl/rsd.xml"> 
  



<link rel="stylesheet" type="text/css" href="index.css" media="all">
</head>
<body>
    <form name="Form1" method="post" action="http://www.cnblogs.com/lwlzyjl/archive/2007/11/07/951904.html" id="Form1">
<div>
<input name="__VIEWSTATE" id="__VIEWSTATE" value="" type="hidden">
</div>

        
<!--done-->
<div id="header">
	
<!--done-->
<div class="header">
	<div class="headerText">
		<a id="Header1_HeaderTitle" class="headermaintitle" href="http://www.cnblogs.com/lwlzyjl/">最远距离</a><br>
		                    ---.Net之路
	</div>
</div>

</div>
<div id="mylinks">
<!--done-->
<a id="MyLinks1_HomeLink" class="menu" href="http://www.cnblogs.com/">博客园</a>&nbsp;&nbsp;&nbsp;
<a id="MyLinks1_MyHomeLink" class="menu" href="http://www.cnblogs.com/lwlzyjl/">首页</a>&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;
<a id="MyLinks1_ContactLink" accesskey="9" class="menu" href="http://space.cnblogs.com/msg/send/%e6%9c%80%e8%bf%9c%e8%b7%9d%e7%a6%bb">联系</a>&nbsp;&nbsp;&nbsp;
<a id="MyLinks1_Syndication" class="menu" href="http://www.cnblogs.com/lwlzyjl/rss">订阅</a><a id="MyLinks1_XMLLink" href="http://www.cnblogs.com/lwlzyjl/rss"><img src="xml.gif" alt="订阅" style="border-width: 0px;"></a>&nbsp;&nbsp;&nbsp;
<a id="MyLinks1_Admin" class="menu" href="http://www.cnblogs.com/lwlzyjl/admin/EditPosts.aspx">管理</a>
</div>
<div id="mytopmenu">
	
		
<div class="blogStats">随笔 - 29&nbsp;
文章 - 1&nbsp;评论 - 76&nbsp;trackbacks - 2
</div>
	
</div>
<div id="leftcontent">
	
		<div id="leftcontentcontainer">
			<br>
			
<!--done-->
<div class="newsItem">
	<div id="ads" style="border: 1px solid rgb(169, 214, 226); margin: 10px 0px 6px; clear: both; width: 180px;">


<h3 style="border-bottom: 1px dashed rgb(161, 216, 230); padding: 2px 0px 0px 12px; font-size: 12px; color: rgb(102, 102, 102); line-height: 24px; height: 24px; text-align: left;">赞助商广告</h3>

<ins style="border: medium none ; margin: 0pt; padding: 0pt; display: inline-table; height: 150px; position: relative; visibility: visible; width: 180px;"><ins style="border: medium none ; margin: 0pt; padding: 0pt; display: block; height: 150px; position: relative; visibility: visible; width: 180px;"><iframe allowtransparency="true" hspace="0" id="google_ads_frame1" marginheight="0" marginwidth="0" name="google_ads_frame" src="index_1.html" style="left: 0pt; position: absolute; top: 0pt;" vspace="0" scrolling="no" frameborder="0" height="150" width="180"></iframe></ins></ins>
<br>
 
<img src="alimamal.php" name="alimamatmpf0.1516593572276438" id="alimamatmpf0.1516593572276438" style="border: 0px none ; margin: 0px; padding: 0px; width: 0px; height: 0px; vertical-align: baseline;" border="0"><iframe name="alimamaf0.1516593572276438" id="alimamaf0.1516593572276438" border="0" marginwidth="0" marginheight="0" style="width: 180px; height: 250px;" src="index_2.html" scrolling="no" frameborder="0"></iframe>
</div>
<div id="profile_block"><a href="http://home.cnblogs.com/lwlzyjl/" target="_top">我的主页</a>&nbsp; <a href="http://home.cnblogs.com/lwlzyjl/detail/" target="_top">个人资料</a><br><a href="http://home.cnblogs.com/lwlzyjl/ing/" target="_top">我的闪存</a>&nbsp; <a href="http://space.cnblogs.com/msg/send/%e6%9c%80%e8%bf%9c%e8%b7%9d%e7%a6%bb" target="_top">发短消息</a></div>
</div>

			

<div class="mySearch">
<h3 class="catListTitle">搜索</h3>
<div class="div_my_zzk"><input value="" id="q" onkeydown="return zzk_go_enter(event);" class="input_my_zzk" type="text">&nbsp;<input onclick="zzk_go()" value="找找看" id="btnZzk" class="btn_my_zzk" type="button"></div>
</div>
<h3>常用链接</h3>
<ul>

		<li><a id="SingleColumn1_ctl01_rptMainLinks_ctl00_lnkLinkItem" href="http://www.cnblogs.com/lwlzyjl/MyPosts.html">我的随笔</a></li>
	
		<li><a id="SingleColumn1_ctl01_rptMainLinks_ctl01_lnkLinkItem" href="http://home.cnblogs.com/lwlzyjl/">我的空间</a></li>
	
		<li><a id="SingleColumn1_ctl01_rptMainLinks_ctl02_lnkLinkItem" href="http://space.cnblogs.com/msg/recent">我的短信</a></li>
	
		<li><a id="SingleColumn1_ctl01_rptMainLinks_ctl03_lnkLinkItem" href="http://www.cnblogs.com/lwlzyjl/MyComments.html">我的评论</a></li>
	
<li><a id="itemListLink" onclick="this.blur();WarpClass('itemListLink', 'itemListLin_con');return false;" href="#">更多链接</a></li>
</ul>
<div id="itemListLin_con" style="display: none;">
<ul>
		<li><a id="SingleColumn1_ctl01_repeaterLinks_ctl01_lnkLinkItem" title="我发表过评论的随笔" href="http://www.cnblogs.com/lwlzyjl/OtherPosts.html">我的参与</a></li>
	
		<li><a id="SingleColumn1_ctl01_repeaterLinks_ctl02_lnkLinkItem" href="http://www.cnblogs.com/lwlzyjl/RecentComments.html">最新评论</a></li>
	
		<li><a id="SingleColumn1_ctl01_repeaterLinks_ctl03_lnkLinkItem" href="http://www.cnblogs.com/lwlzyjl/tag/">我的标签</a></li>
	</ul>
</div>
<!--done-->

		<h1 class="catListTitle">随笔分类</h1>
		
				<ul class="catList">
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl01_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/89131.html">Ajax</a><a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl01_RssLink" title="Subscribe to Ajax" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/89131.html/rss"><img title="Subscribe to Ajax" src="xml_001.gif" style="border-width: 0px;"></a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl02_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/89043.html">Asp.net(2)</a><a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl02_RssLink" title="Subscribe to Asp.net(2)" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/89043.html/rss"><img title="Subscribe to Asp.net(2)" src="xml_001.gif" style="border-width: 0px;"></a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl03_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/200093.html">Asp.Net MVC开发指南</a><a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl03_RssLink" title="Subscribe to Asp.Net MVC开发指南" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/200093.html/rss"><img title="Subscribe to Asp.Net MVC开发指南" src="xml_001.gif" style="border-width: 0px;"></a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl04_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/89042.html">C#(6)</a><a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl04_RssLink" title="Subscribe to C#(6)" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/89042.html/rss"><img title="Subscribe to C#(6)" src="xml_001.gif" style="border-width: 0px;"></a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl05_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/89044.html">JavaScript</a><a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl05_RssLink" title="Subscribe to JavaScript" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/89044.html/rss"><img title="Subscribe to JavaScript" src="xml_001.gif" style="border-width: 0px;"></a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl06_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/89045.html">XML</a><a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl06_RssLink" title="Subscribe to XML" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/89045.html/rss"><img title="Subscribe to XML" src="xml_001.gif" style="border-width: 0px;"></a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl07_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/197675.html">翻译文章</a><a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl07_RssLink" title="Subscribe to 翻译文章" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/197675.html/rss"><img title="Subscribe to 翻译文章" src="xml_001.gif" style="border-width: 0px;"></a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl08_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/97199.html">日常积累(3)</a><a id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl08_RssLink" title="Subscribe to 日常积累(3)" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/97199.html/rss"><img title="Subscribe to 日常积累(3)" src="xml_001.gif" style="border-width: 0px;"></a></li>
			
				</ul>
			
	
		<h1 class="catListTitle">随笔档案</h1>
		
				<ul class="catList">
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl01_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/archive/2009/04.html">2009年4月 (1)</a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl02_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/archive/2008/12.html">2008年12月 (1)</a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl03_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/archive/2008/08.html">2008年8月 (1)</a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl04_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/archive/2008/05.html">2008年5月 (1)</a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl05_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/archive/2008/04.html">2008年4月 (4)</a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl06_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/archive/2008/01.html">2008年1月 (3)</a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl07_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/archive/2007/11.html">2007年11月 (8)</a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl08_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/archive/2007/10.html">2007年10月 (3)</a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl09_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/archive/2007/09.html">2007年9月 (5)</a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl10_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/archive/2007/08.html">2007年8月 (1)</a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl11_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/archive/2007/06.html">2007年6月 (1)</a></li>
			
				</ul>
			
	
		<h1 class="catListTitle">文章分类</h1>
		
				<ul class="catList">
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl02_LinkList_ctl01_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/89046.html">.Net</a><a id="SingleColumn1_Categories_CatList_ctl02_LinkList_ctl01_RssLink" title="Subscribe to .Net" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/89046.html/rss"><img title="Subscribe to .Net" src="xml_001.gif" style="border-width: 0px;"></a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl02_LinkList_ctl02_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/132159.html">Spring.Net(1)</a><a id="SingleColumn1_Categories_CatList_ctl02_LinkList_ctl02_RssLink" title="Subscribe to Spring.Net(1)" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/132159.html/rss"><img title="Subscribe to Spring.Net(1)" src="xml_001.gif" style="border-width: 0px;"></a></li>
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl02_LinkList_ctl03_Link" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/130788.html">漫谈设计模式</a><a id="SingleColumn1_Categories_CatList_ctl02_LinkList_ctl03_RssLink" title="Subscribe to 漫谈设计模式" class="listitem" href="http://www.cnblogs.com/lwlzyjl/category/130788.html/rss"><img title="Subscribe to 漫谈设计模式" src="xml_001.gif" style="border-width: 0px;"></a></li>
			
				</ul>
			
	
		<h1 class="catListTitle">好友的Blog</h1>
		
				<ul class="catList">
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl03_LinkList_ctl01_Link" class="listitem" href="http://www.6868368.com/">奇特淘宝网</a></li>
			<li style="margin-top: 2px;">奇特淘宝网</li>
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl03_LinkList_ctl02_Link" class="listitem" href="http://hunbj.cn/" target="_top">我的个人网站</a></li>
			<li style="margin-top: 2px;">混北京网站</li>
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl03_LinkList_ctl03_Link" class="listitem" href="http://www.blogjava.net/Alex-Lee/default.aspx" target="_top">小颀的Java窝</a><a id="SingleColumn1_Categories_CatList_ctl03_LinkList_ctl03_RssLink" title="Subscribe to 小颀的Java窝" class="listitem" href="http://www.blogjava.net/Alex-Lee/default.aspx"><img title="Subscribe to 小颀的Java窝" src="xml_001.gif" style="border-width: 0px;"></a></li>
			
				</ul>
			
	
		<h1 class="catListTitle">牛人的Blog</h1>
		
				<ul class="catList">
			
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl04_LinkList_ctl01_Link" class="listitem" href="http://juqiang.cnblogs.com/" target="_top">鞠强的Blog</a></li>
			<li style="margin-top: 2px;">Inspur出去的高手, 敬仰之~!</li>
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl04_LinkList_ctl02_Link" class="listitem" href="http://blog.csdn.net/eparg" target="_top">熊力的Blog</a><a id="SingleColumn1_Categories_CatList_ctl04_LinkList_ctl02_RssLink" title="Subscribe to 熊力的Blog" class="listitem" href="http://blog.csdn.net/eparg/Rss.aspx"><img title="Subscribe to 熊力的Blog" src="xml_001.gif" style="border-width: 0px;"></a></li>
			<li style="margin-top: 2px;">据说是个调试的高手,想买他的书看看!</li>
				<li class="catListItem"> <a id="SingleColumn1_Categories_CatList_ctl04_LinkList_ctl03_Link" class="listitem" href="http://blog.joycode.com/wayfarer/" target="_top">张逸:晴窗笔记</a></li>
			<li style="margin-top: 2px;">WCF的牛人！</li>
				</ul>
			
	


<h3>积分与排名</h3>
<ul>
	<li>
		积分 -
		22167
	</li><li>
		排名 -
		3134
	</li>
</ul>

<h3 class="catListTitle">最新评论
	<a id="SingleColumn1__2e3d8b6_RSSHyperlink1" href="http://www.cnblogs.com/lwlzyjl/CommentsRSS.aspx"><img src="xml.gif" style="border-width: 0px;"></a></h3>
<div class="RecentComment" id="RecentComments">
	
			<ul>
		
			<li style="">
				<a id="SingleColumn1__2e3d8b6_CommentList_ctl01_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2008/01/02/1023531.html#1735143">1.&nbsp;Re:excel单元格回车的使用 </a>
			</li>
			<li style="">
				非常感谢哈 一直为之个问题头疼哈
			</li>
			<li style="text-align: right; margin-right: 4px;">
				--alisx</li>
		
			<li style="">
				<a id="SingleColumn1__2e3d8b6_CommentList_ctl02_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2008/01/02/1023531.html#1733450">2.&nbsp;Re:excel单元格回车的使用 </a>
			</li>
			<li style="">
				非常感谢，及时解决了工作中的问题
			</li>
			<li style="text-align: right; margin-right: 4px;">
				--某某1</li>
		
			<li style="">
				<a id="SingleColumn1__2e3d8b6_CommentList_ctl03_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2008/05/07/1186699.html#1695038">3.&nbsp;Re:Spring.Net入门篇（二）概述 </a>
			</li>
			<li style="">
				写这篇概述，实在让我感觉捉肘见襟，不停的翻阅材料，也许一年以后我再看这篇的文章的时候会发现现在的我是多么的幼稚和可笑，但是我还是写出来了，当作对逝去的时光的一个总结吧！


楼主，你现在看时，可千万别...
			</li>
			<li style="text-align: right; margin-right: 4px;">
				--梅桦</li>
		
			<li style="">
				<a id="SingleColumn1__2e3d8b6_CommentList_ctl04_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2008/12/11/1353112.html#1688875">4.&nbsp;Re:大型网站架构演变和知识体系(转)</a>
			</li>
			<li style="">
				受教了！
			</li>
			<li style="text-align: right; margin-right: 4px;">
				--孤独之影</li>
		
			<li style="">
				<a id="SingleColumn1__2e3d8b6_CommentList_ctl05_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2008/05/07/1186699.html#1672907">5.&nbsp;Re:Spring.Net入门篇（二）概述 </a>
			</li>
			<li style="">
				看得真是太爽啦!

			</li>
			<li style="text-align: right; margin-right: 4px;">
				--我是一只小老虎 喵!</li>
		
			</ul>
		
</div>

<h3 class="catListTitle">阅读排行榜</h3>
<div class="RecentComment" id="TopViewPosts"> 
	
			<ul style="">
		
			<li>
				<a id="SingleColumn1_ctl04_TopList_ctl01_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2008/04/18/1159712.html">1.&nbsp;Spring.Net入门篇（一）(4349)</a>
			</li>
		
			<li>
				<a id="SingleColumn1_ctl04_TopList_ctl02_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2008/04/08/1142382.html">2.&nbsp;.Net的序列化和反序列化(3605)</a>
			</li>
		
			<li>
				<a id="SingleColumn1_ctl04_TopList_ctl03_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2008/05/07/1186699.html">3.&nbsp;Spring.Net入门篇（二）概述 (3523)</a>
			</li>
		
			<li>
				<a id="SingleColumn1_ctl04_TopList_ctl04_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2008/01/02/1023531.html">4.&nbsp;excel单元格回车的使用 (2214)</a>
			</li>
		
			<li>
				<a id="SingleColumn1_ctl04_TopList_ctl05_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2007/11/08/953258.html">5.&nbsp;NuSoap介绍（转）(1154)</a>
			</li>
		
			</ul>
		
</div>

<h3 class="catListTitle">评论排行榜</h3>
<div class="RecentComment" id="TopCommentsPosts">
	
			<ul style="">
		
			<li>
				<a id="SingleColumn1_ctl05_TopList_ctl01_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2008/05/07/1186699.html">1.&nbsp;Spring.Net入门篇（二）概述 (31)</a>
			</li>
		
			<li>
				<a id="SingleColumn1_ctl05_TopList_ctl02_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2008/04/18/1159712.html">2.&nbsp;Spring.Net入门篇（一）(21)</a>
			</li>
		
			<li>
				<a id="SingleColumn1_ctl05_TopList_ctl03_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2008/04/08/1142382.html">3.&nbsp;.Net的序列化和反序列化(10)</a>
			</li>
		
			<li>
				<a id="SingleColumn1_ctl05_TopList_ctl04_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2008/01/02/1023531.html">4.&nbsp;excel单元格回车的使用 (8)</a>
			</li>
		
			<li>
				<a id="SingleColumn1_ctl05_TopList_ctl05_Hyperlink1" href="http://www.cnblogs.com/lwlzyjl/archive/2007/11/15/960294.html">5.&nbsp;用Axis开发Webservice(2)</a>
			</li>
		
			</ul>
		
</div></div>		
	
</div>
<div id="centercontent">
	
					
<!--done-->
<div class="post">
	<div class="postTitle">
		<h1><a id="ctl04_TitleUrl" class="postTitle2" href="http://www.cnblogs.com/lwlzyjl/archive/2007/11/07/951904.html">关于开启Sql Server 2005 Express版本的远程连接功能（备忘） </a></h1>
	</div>
	<p>感谢 workflow ！！<br>
解决方式如下：<br>
<font face="Courier New"><span><a href="http://www.cnblogs.com/workflow/archive/2007/04/28/731272.html" class="smarterwiki-linkify">http://www.cnblogs.com/workflow/archive/2007/04/28/731272.html</a></span><br>
主要要做的事情有：<br>
1、登陆改为混合模式：以windows方式连接并进入数据库，右键点击你的数据服务器-&gt;属性-&gt;安全性&gt;选中Sql server 和windows 验证方式。<br>
2、启用TCP/IP和Named Pipes：进入Sql Server配置管理器，在网络配置-&gt;SqlExpress的协议中启用。<br>
3、启用远程连接：sql server外围应用配置器-&gt;服务和连接的外围应用配置器-&gt;打开MSSQLSERVER节点下的Database Engine 节点，先择"远程连接"，选择"同时使用TCP/IP和named pipes"<br>
<br>
重启服务，一般这样配置后通过.\sqlexpress就能访问数据库了（除非防火墙问题），但如果是在另外一台电脑来访问的话，还是不行（在本机用127.0.0.1\sqlexpress也不行）。<br>
<br>
后来找了n久资料，终于看到<span style="color: red;">要开启Sql Server Browser服务</span>！（在配置管理器-&gt;Sql Server 2005服务里面开启）。开启后就能在其他机器上来访问sql了。 <br>
WorkFlow 老兄的Blog<br>
<font face="Courier New"><span><a href="http://www.cnblogs.com/workflow/" class="smarterwiki-linkify">http://www.cnblogs.com/workflow/</a></span></font></font></p>

<div id="digg_block">
<div id="div_digg">										
	<div class="diggit" onclick="DiggIt(951904,18036,1)"> 
		<span class="diggnum" id="digg_count_951904">0</span>
	</div>
	<div class="buryit" onclick="DiggIt(951904,18036,2)"> 
		<span class="burynum" id="bury_count_951904">0</span>
	</div>
	<div class="clear"></div>
	<span style="display: none;" id="span_isdigged_951904">0</span>	
	<div class="diggword" id="digg_word_951904">(请您对文章做出评价)</div>	
</div>
</div>
<div class="clear"></div>
<div id="post_next_prev">
<a href="http://www.cnblogs.com/lwlzyjl/archive/2007/11/05/949883.html">« </a> 上一篇：<a href="http://www.cnblogs.com/lwlzyjl/archive/2007/11/05/949883.html" title="发布于2007-11-05 15:09">Internet Explorer 编程简述</a><br>
<a href="http://www.cnblogs.com/lwlzyjl/archive/2007/11/07/952354.html">» </a> 下一篇：<a href="http://www.cnblogs.com/lwlzyjl/archive/2007/11/07/952354.html" title="发布于2007-11-07 16:58">IE Plug-In （1）</a><br>
</div>








	<div class="postDesc">posted on 2007-11-07 11:05 <a href="http://www.cnblogs.com/lwlzyjl/">最远距离</a> 阅读(861) <a href="#commentform">评论(1)</a> &nbsp;<a href="http://www.cnblogs.com/lwlzyjl/admin/EditPosts.aspx?postid=951904">编辑</a> <a href="http://www.cnblogs.com/lwlzyjl/AddToFavorite.aspx?id=951904">收藏</a> <a href="#" onclick="PutInWz();return false;">网摘</a>  </div>
</div>
<img src="951904.html" height="1" width="1">

<!--
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:dc="http://purl.org/dc/elements/1.1/"
xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/">
<rdf:Description
rdf:about="http://www.cnblogs.com/lwlzyjl/archive/2007/11/07/951904.html"
dc:identifier="http://www.cnblogs.com/lwlzyjl/archive/2007/11/07/951904.html"
dc:title=""
trackback:ping="http://www.cnblogs.com/lwlzyjl/services/trackbacks/951904.aspx" />
</rdf:RDF>
-->



<div id="ctl05_comment_form" class="commentform">




<div id="ctl05_divLoginPannel">
<div class="login_tips">注册用户登录后才能发表评论，请 <a href="http://passport.cnblogs.com/login.aspx?ReturnUrl=http%3a%2f%2fwww.cnblogs.com%2flwlzyjl%2farchive%2f2007%2f11%2f07%2f951904.html%3flogin%3d1%23commentform" class="underline">登录</a> 或 <a href="http://passport.cnblogs.com/register.aspx?ReturnUrl=http%3a%2f%2fwww.cnblogs.com%2flwlzyjl%2farchive%2f2007%2f11%2f07%2f951904.html%23Bottom2" class="underline">注册</a> 。</div>
</div>

<div class="itnews c_ad_block" id="itnews">
<a href="http://news.cnblogs.com/" target="_top">IT新闻</a>:<br>

          ·  <a href="http://news.cnblogs.com/n/55140/" target="_top">《星际争霸2》"刀锋女王"重金属主题音乐视频</a><br>
	
          ·  <a href="http://news.cnblogs.com/n/55139/" target="_top">中国站长最郁闷的几件事情</a><br>
	
          ·  <a href="http://news.cnblogs.com/n/55138/" target="_top">苹果Vs谷歌：手机领域谁怕谁？</a><br>
	
          ·  <a href="http://news.cnblogs.com/n/55137/" target="_top">摩托罗拉：豪赌Android的希望与隐忧</a><br>
	
          ·  <a href="http://news.cnblogs.com/n/55136/" target="_top">分众新坐标：楼宇是过去 未来在手机和互联网</a><br>
	
</div>


<div id="ad_under_comment" class="c_ad_block">
<a href="http://a4.yeshj.com/rd/34138/" target="_top">每天10分钟，轻松学英语</a><br><br>
<div id="google_ads_div_cnblogs_blogpost_bottom1">
<iframe src="index_3.html" style="border: 0pt none ;" marginheight="0" marginwidth="0" name="google_ads_iframe_cnblogs_blogpost_bottom1" id="google_ads_iframe_cnblogs_blogpost_bottom1" scrolling="no" frameborder="0" height="60" width="468"></iframe></div>

<br>
<div id="google_ads_div_cnblogs_blogpost_bottom">
<iframe src="index_4.html" style="border: 0pt none ;" marginheight="0" marginwidth="0" name="google_ads_iframe_cnblogs_blogpost_bottom" id="google_ads_iframe_cnblogs_blogpost_bottom" scrolling="no" frameborder="0" height="250" width="300"></iframe></div>

</div>
<div id="site_nav_under" class="c_ad_block">
网站导航：<br>
<a href="http://www.cnblogs.com/" target="_top">博客园首页</a> &nbsp;<a href="http://news.cnblogs.com/" target="_top">IT新闻</a> &nbsp;<a href="http://home.cnblogs.com/" target="_top">个人主页</a> &nbsp;<a href="http://home.cnblogs.com/ing/" target="_top">闪存</a> &nbsp;<a href="http://job.cnblogs.com/" target="_top">程序员招聘</a> &nbsp;<a href="http://space.cnblogs.com/" target="_top">社区</a> &nbsp;<a href="http://space.cnblogs.com/q/" target="_top">博问</a> &nbsp;<a href="http://wz.cnblogs.com/" target="_top">网摘</a>
</div>
<div id="ad_under_comment2" class="c_ad_block">
<a href="http://www.china-pub.com/STATIC07/0912/zh_ndcx_091212.asp" target="_top"><img src="chinapub_20091222.jpg" alt="" style="border: 0px none ;"></a><br>
<a href="http://www.china-pub.com/itbook/" target="_top">China-pub 计算机图书网上专卖店！6.5万品种2-8折！</a><br>
<a href="http://www.china-pub.com/static07/0901/zh_jueba_090121.asp" target="_top">China-Pub 计算机绝版图书按需印刷服务</a><br>
</div>

<div id="relative_search"><br><b>在知识库中查看：</b><br> <a href="http://kb.cnblogs.com/a/951904/">关于开启Sql Server 2005 Express版本的远程连接功能（备忘） </a></div>

</div>


				
	
<!--done-->
<div class="footer">
	
	Copyright ©2010 最远距离 Powered by: <a href="http://www.cnblogs.com/" class="footerlink">博客园</a> 模板提供：<a href="http://blog.hjenglish.com/" class="footerlink">沪江博客</a><br>
</div>
</div>



    </form>
	
	
      
    
    
    
</body>
</html>
